﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetSubastaByFecha')
	BEGIN
		DROP  Procedure  GetSubastaByFecha
	END

GO

CREATE Procedure GetSubastaByFecha
(
	@fecha datetime
)
AS
BEGIN
	SELECT * FROM Subasta WHERE FechaSubasta <= @fecha
END

GO


GRANT EXEC ON GetSubastaByFecha TO PUBLIC

GO


